Business Analytics for Yandex.Afisha

Project description


Yandex.Afisha looking to optimize marketing expenses.

Provided data:What needs to be studied:

Table of contents

  1. Downloading and preparing the data
  2. Analysis
  3. Conclusion

1. Downloading and preparing the data

Orders

Visits

Costs

Data types were changed, missing values and duplicates were checked. The data sets are ready for the analysis.


2. Analysis

2.1 Product

2.1.1 DAU, WAU, MAU

There is a peak of number of users in cold months (from october till march) and decrease in warm months. It can be related to seasonality - people more interested in different events during cold months. Also it can be related to marketing budget and strategy that were used in different months.

The same trend is seen on weekly activity with outstanding peak on one particular week in november.

When looking on daily number of unique users, first of all we see two outstanding values:

  • 2017-11-24 with record number of users, that obviously was the reason of the peak on the graph of weekly activity.
  • 2018-03-31 with only 1 user. Maybe site didn't work on that day or for some reason statistics for that day wasn't collected, but it's obviously related to smoe technical issue.

Also we can see specificity of users activity during the week - more users visited the site during weekdays than on weekends.</font>